General Ledger Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
AcctClassId smallint 2

 

    
Desc nvarchar 30      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AcctId pGlAcct 40      
Year smallint 2 0    
Period smallint 2 0    
Actual pCurrDec 13 0    
ActualBase pCurrDec 13 0    
Budget pCurrDec 13 0    
Forecast pCurrDec 13 0    
Balance pCurrDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BFAcctDtlRef int 4      
AcctID pGlAcct 40      
BFRef int 4      
GlPeriod smallint 2      
GlYear smallint 2      
Amount pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AcctId pGlAcct 40      
Desc nvarchar 30      
AcctTypeId smallint 2      
BalType smallint 2 -1 Balance Type 0 = Memo, 1 = Debit, -1 = Credit
ClearToAcct pGlAcct 40      
ClearToStep tinyint 1 0    
ConsolToAcct pGlAcct 40      
ConsolToStep tinyint 1 0    
Status tinyint 1 0 GL Account Status 0 = Active, 1 = Inactive, 2 = Discontinued
CurrencyID pCurrency 6      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CompId nvarchar 3      
CurYear smallint 2      
MaskFormat nvarchar 512      
MaskInput nvarchar 512      
NumSegs tinyint 1 -1 GL Account Number of Segments 1, 2, 3, 4, 5, 6, 7
FillChar nvarchar 1   GL Account Mask Fill Character NULL = None, 1 = Space( ), -(Hyphen) = Hyphen(-), .(Period) = Period(.), :(Colon) = Colon(:), /(Slash) = Slash(/)
Case nvarchar 1 0 GL Account Mask Case 0 = Either, < = Lower, > = Upper
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Abbreviation varchar 4      
Description varchar 20      
Length tinyint 1      
Mask varchar 12      
Number int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AcctTypeId smallint 2 0    
Desc nvarchar 30      
AcctClassId smallint 2 0    
AcctCode smallint 2 0 GL Account Type 0 = Memo, 1 = Debit, -1 = Credit
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SegType varchar 2   GL Account / Account Segment Type 1 = Segment 1, 2 = Segment 2, 3 = Segment 3, 4 = Segment 4, 5 = Segment 5, 6 = Segment 6, 7 = Segment 7, A = Full Account
SegId pGlAcct 40      
ToCompId pCompID 3      
AcctIdCredit pGlAcct 40      
AcctIdDebit pGlAcct 40      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
SegType varchar 2   GL Account / Account Segment Type 1 = Segment 1, 2 = Segment 2, 3 = Segment 3, 4 = Segment 4, 5 = Segment 5, 6 = Segment 6, 7 = Segment 7, A = Full Account
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AcctId pGlAcct 40      
AllocToAcctId pGlAcct 40      
AllocPct pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AcctId pGlAcct 40      
Desc nvarchar 30      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransAllocId nvarchar 10      
Counter int 4      
Segments pGlAcct 40      
AllocPct pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransAllocId nvarchar 10      
Desc nvarchar 30      
ExpDate datetime 8      
SegmentFlags pGlAcct 40      
Notes text 16      
CF xml -1      

tblGlBudFrcstComp -- GL Budget Forecast Composition table

tblGlBudFrcstCompExcl -- GL Budget Forecast Composition Exclusion table

tblGlBudFrcstDescr -- GL Budget Forecast Description table

tblGlCashFlowDtl -- GL Cash Flow Detail table

tblGlCashFlowHdr -- GL Cash Flow Header table

Column Name Column Type Length Default Value Description Enumeration
ID int 4      
EntryDate datetime 8 getdate()    
TransDate datetime 8 getdate()    
PostRun pPostRun 14      
AcctIDOffset pGlAcct 40      
AcctIDGainLoss pCurrDec 13      
AmountGainLoss pCurrDec 13      
AmountBase pCurrDec 13      
FiscalPeriod smallint 2 0    
FiscalYear smallint 2 0    
FunctionID nvarchar 10      
SourceCode nvarchar 2      
LinkPostRun pPostRun 14      
LinkID nvarchar 15      
LinkIDSub nvarchar 15      
LinkIDSubLine int 4 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryNum int 4      
CompId nvarchar 3      
EntryDate datetime 8 getdate()    
TransDate datetime 8 getdate()    
PostedYn smallint 2 0    
Desc nvarchar 30      
SourceCode varchar 2 'm1' Transaction Source Code <AppID> = Source Application, AL = GL Automatic Allocation, CL = GL Year-End Closing, M<#> = Manual Entry, R1 = GL Auto-Reversing Accrual, R2 = GL Reversal Entry of Matching R1, RE = GL Recurring Entry
Reference nvarchar 15      
AcctId pGlAcct 40      
DebitAmt pCurrDec 13 0    
CreditAmt pCurrDec 13 0    
Period smallint 2 0    
Year smallint 2 0    
AllocateYn bit 1 -1    
ChkRecon bit 1 0    
CashFlow bit 1 -1    
LinkID nvarchar 15      
LinkIDSub nvarchar 15      
LinkIDSubLine int 4 0    
PostRun pPostRun 14 0    
ExchRate pDec 13 -*-1    
CurrencyID pCurrency 6      
DebitAmtFgn pCurrDec 13 0    
CreditAmtFgn pCurrDec 13 0    
URG bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
EntryNum int 4      
CompId nvarchar 3      
EntryDate datetime 8 getdate()    
TransDate datetime 8 getdate()    
PostedYn smallint 2 -1    
Desc nvarchar 30      
SourceCode varchar 2 'm1' Transaction Source Code <AppID> = Source Application, AL = GL Automatic Allocation, CL = GL Year-End Closing, M<#> = Manual Entry, R1 = GL Auto-Reversing Accrual, R2 = GL Reversal Entry of Matching R1, RE = GL Recurring Entry
Reference nvarchar 15      
AcctId pGlAcct 40      
DebitAmt pCurrDec 13 0    
CreditAmt pCurrDec 13 0    
Period smallint 2 0    
Year smallint 2 0    
AllocateYn bit 1 -1    
ChkRecon bit 1 0    
CashFlow bit 1 0    
LinkID nvarchar 15      
LinkIDSub nvarchar 15      
LinkIDSubLine int 4 0    
PostRun pPostRun 14 0    
ExchRate pDec 13 -1    
CurrencyID pCurrency 6      
DebitAmtFgn pCurrDec 13 0    
CreditAmtFgn pCurrDec 13 0    
URG bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
GroupId nvarchar 10      
LineNum real 4 0    
AcctNum pGlAcct 40      
Desc nvarchar 30      
DebitAmt pCurrDec 13 0    
CreditAmt pCurrDec 13 0    
Alloc bit 1 0    
SourceCode varchar 2 're' Recurring Entries Source Code R1 = GL Auto-Reversing Accrual, RE = GL Recurring Entry
Reference nvarchar 15      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
GroupId nvarchar 10      
Desc nvarchar 25      
Template bit 1 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 25      
Id varchar 12      
Number int 4      
CF xml -1      
ts timestamp 8      

tblGlSrcCode -- GL Source Code table

tblGlStmt -- GL Statement table

tblGlStmtBatch -- GL Statement Batch table

tblGlStmtBatchDtl -- GL Statement Batch Detail table

tblGlStmtCol -- GL Statement Column table

tblGlStmtColDtl -- GL Statement Column Detail table

tblGlStmtRow -- GL Statement Row table

tblGlStmtRowDtl -- GL Statement Row Detail table

Column Name Column Type Length Default Value Description Enumeration
TransId uniqueidentifier 16      
EntryDate datetime 8      
TransDate datetime 8      
Descr varchar 30      
SourceCode varchar 2      
Reference varchar 15      
AcctId pGlAcct 40      
CurrencyId pCurrency 6      
ExchRate pDecimal 13      
DebitAmountFgn pCurrDec 13 0    
CreditAmountFgn pCurrDec 13 0    
FiscalYear smallint 2 0    
FiscalPeriod smallint 2 0    
AllocateYn bit 1 0    
ChkRecon bit 1 0    
UserId pUserID 20      
AllocParentId uniqueidentifier 16      
CashFlow bit 1 0    
LineSequence int 4 0    
CF xml -1      
ts timestamp 8